Package excel.adddatatocells

Source Code of excel.adddatatocells.AsposeInsertCellsData

package excel.adddatatocells;

import com.aspose.cells.Cell;
import com.aspose.cells.Cells;
import com.aspose.cells.Style;
import com.aspose.cells.Workbook;
import com.aspose.cells.Worksheet;

public class AsposeInsertCellsData
{
  public static void main(String[] args) throws Exception
  {
    //Instantiating a Workbook object
    Workbook workbook = new Workbook();
   
    //Accessing the added worksheet in the Excel file
    Worksheet worksheet = workbook.getWorksheets().get(0);
    Cells cells = worksheet.getCells();
   
    cells.get("A1").setValue("Hello World"); //Adding a string value to the cell
    cells.get("A2").setValue(20.5); //Adding a double value to the cell
    cells.get("A3").setValue(15); //Adding an integer  value to the cell
    cells.get("A4").setValue(true); //Adding a boolean value to the cell
   
    Cell cell = cells.get("A5"); //Adding a date/time value to the cell
    cell.setValue(java.util.Calendar.getInstance());
   
    //Setting the display format of the date
    Style style = cell.getStyle();
    style.setNumber(15);
    cell.setStyle(style);
   
    workbook.save("data/DataInCells_Aspose.xls"); //Saving the Excel file

// Print message
System.out.println("Data Added Successfully");
  }
}
TOP

Related Classes of excel.adddatatocells.AsposeInsertCellsData

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.